package com.exercise240710.mapper;

import com.exercise240710.entity.PhysicalTest;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface PhysicalTestMapper {
    public int deletePhysicalByIdSeq(String id_seq);

    public List<PhysicalTest> selectPhysicalByCondition(
            Long min_id, Long max_id, String id_seq, Float min_height,
            Float max_height, Float min_weight, Float max_weight,
            Short min_vital_capacity, Short max_vital_capacity,
            Float min_seated_forward_bend, Float max_seated_forward_bend,
            Short min_standing_long_jump, Short max_standing_long_jump,
            Float min_rush_50, Float max_rush_50, Float min_long_distance_run,
            Float max_long_distance_run, Short min_sit_ups, Short max_sit_ups,
            String test_date, Long min_student_id, Long max_student_id,
            Long offset, Integer pageSize
    );

    public int insertPhysical(
            String id_seq,
            Float height,
            Float weight,
            Short vital_capacity,
            Float seated_forward_bend,
            Short standing_long_jump,
            Float rush_50,
            Float long_distance_run,
            Short sit_ups,
            String test_date,
            Long student_id
    );

    public List<PhysicalTest> selectPhysicalByStudentId(Long student_id);

    public List<PhysicalTest> selectPhysicalByStudentIds(List<Long> student_ids);


}
